package com.xinqi.modules.stats.score.mapper;

import com.xinqi.common.mybatis.data.repo.SuperMapper;
import com.xinqi.modules.stats.score.domain.CourseTotalScoreStudentEntity;
import com.xinqi.modules.stats.score.dto.req.*;
import com.xinqi.modules.stats.score.dto.rsp.*;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

/**
 * 总成绩学生各栏目成绩基础数据表数据层
 *
 * @author: system
 * @date: 2023/03/26
 */
@Mapper
public interface CourseTotalScoreStudentMapper extends SuperMapper<CourseTotalScoreStudentEntity> {

    /**
     * PC总成绩柱状图统计
     */
    List<StudentTotalScoreBaseResultDTO> studentTotalScoreColumnList(CourseTotalScoreClassDTO dto);

    /**
     * 学生课程已结束内容栏目表头统计列表
     */
    List<CourseContentTotalTipDTO> studentTypeScoreTitle(CourseTotalScoreStudentQueryDTO dto);

    /**
     * 学生课程已结束内容栏目学生得分行转列
     */
    @MapKey("student_id")
    List<Map<String, Object>> studentTypeScoreList(CourseTotalScoreStudentRowsQueryDTO dto);

}
